package com.sl.au.repository;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.transaction.annotation.Transactional;

import com.sl.au.entity.ExdeContractBillAgingLedger;

/**
 * 
 * @author yry
 * 2017-03-10
 *
 */
@Transactional(readOnly = true)
public interface ExdeContractBillAgingLedgerRepository extends JpaRepository<ExdeContractBillAgingLedger,String>{
	
	/**
	 * 
	 * @param cContractId 合同ID
	 * @param YearAndMonth 当前年月
	 * @return
	 */
	@Query("select c from ExdeContractBillAgingLedger c where c.cContractId=?1 and c.dNotionalPoolingYearAndMonth=?2")
	ExdeContractBillAgingLedger findStatisticsById(String cContractId,String YearAndMonth);

}
